package com.example.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.MS;
import com.example.entity.Post;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface PostDao extends BaseMapper<Post> {

    @Select("select commercial_name,COUNT(commercial_name) as number from post group by commercial_name ORDER BY number")
    public List<MS> getRecruitmentByPost();
}
